package com.atguigu.edusugar.mapper;

import com.atguigu.edusugar.bean.exam;
import org.apache.ibatis.annotations.Select;

import java.awt.print.Paper;
import java.util.List;
import java.util.Map;

public interface TrafficMapper {
    @Select("SELECT\n" +
            "    paper_id,\n" +
            "    avg_score / sum_exam_ct AS avg_score,\n" +
            "    avg_exam_time / sum_exam_ct AS avg_exam_time\n" +
            "FROM dws_exam_test_paper_uu_window\n" +
            "WHERE toYYYYMMDD(stt) = #{date}\n")
    List<exam> exam(int date);
    //要查什么就常见一个他的指标


}
